﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPages/Site.Master" AutoEventWireup="true" CodeBehind="WFVisualizaTarefaFuncionario.aspx.cs" Inherits="s2b.ControleDesenvolvimentoProjetos.WFVisualizaTarefaFuncionario" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <asp:SqlDataSource ID="DSTarefaFunc" runat="server" 
        ConnectionString="<%$ ConnectionStrings:CS_DB_Controle_Projeto %>" 
        SelectCommand="SELECT T.ID_TAREFA AS [Id tarefa], P.DESC_PROJETO AS [Descrição do projeto], F.NOME_FUNC AS Colaborador, T.DETALHE_TAREFA AS Tarefa, T.DT_INICIO_TAREF AS [Data inicial], T.DT_FINAL_TAREFA AS [Data final], T.CARGA_HORARIA AS [Carga horária], T.CARG_HOR_UTILIZ AS [Carga horária utilizada] FROM TAREFAS AS T INNER JOIN PROJETO AS P ON P.ID_PROJETO = T.ID_PROJETO INNER JOIN FUNCIONARIO AS F ON F.ID_FUNC = T.ID_FUNC WHERE (P.ID_PROJETO = @ID_PROJETO) AND (F.ID_FUNC = @ID_FUNC)">
        <SelectParameters>
            <asp:QueryStringParameter Name="ID_PROJETO" QueryStringField="ID_PROJETO" />
            <asp:QueryStringParameter Name="ID_FUNC" QueryStringField="ID_FUNCIONARIO" />
        </SelectParameters>
    </asp:SqlDataSource>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"  Width="100%"
        DataKeyNames="Id tarefa" DataSourceID="DSTarefaFunc" BackColor="White" 
        BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px" CellPadding="3" 
        ForeColor="Black" GridLines="Vertical">
        <AlternatingRowStyle BackColor="#CCCCCC" />
        <Columns>
            <asp:BoundField DataField="Id tarefa" HeaderText="Id tarefa" 
               Visible="False" ReadOnly="True" SortExpression="Id tarefa" />
            <asp:BoundField DataField="Descrição do projeto" 
                HeaderText="Descrição do projeto" SortExpression="Descrição do projeto" />
            <asp:BoundField DataField="Colaborador" HeaderText="Colaborador" 
                SortExpression="Colaborador" />
            <asp:BoundField DataField="Tarefa" HeaderText="Tarefa" 
                SortExpression="Tarefa" />
            <asp:BoundField DataField="Data inicial" HeaderText="Data inicial" 
                SortExpression="Data inicial" />
            <asp:BoundField DataField="Data final" HeaderText="Data final" 
                SortExpression="Data final" />
            <asp:BoundField DataField="Carga horária" HeaderText="Carga horária" 
                SortExpression="Carga horária" />
            <asp:BoundField DataField="Carga horária utilizada" 
                HeaderText="Carga horária utilizada" SortExpression="Carga horária utilizada" />
        </Columns>
        <FooterStyle BackColor="#CCCCCC" />
        <HeaderStyle BackColor="#000040" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#999999" ForeColor="#000040" HorizontalAlign="Center" />
        <SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
        <SortedAscendingCellStyle BackColor="#F1F1F1" />
        <SortedAscendingHeaderStyle BackColor="#808080" />
        <SortedDescendingCellStyle BackColor="#CAC9C9" />
        <SortedDescendingHeaderStyle BackColor="#383838" />
    </asp:GridView>
</asp:Content>
